{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Date_Range"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Date_Range","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,1,16,8],[15,1,15,8],[13,1,13,8],[12,1,12,8],[0,1,1,8],[2,4,2,5],[2,1,2,2],[3,1,3,2]]}
[null,"Please make sure you enable macro's and data connection content, if prompted!"]
[]
[null,"Step 1",null,null,"Step 2",null,null,null,null,null,null,"This includes patient demographic details:"]
[null,"Enter Appointment Date Range",null,null,null,null,null,null,null,null,null,"RegistrationStatus"]
[null,"FROM","TO",null,"Count",null,null,null,null,null,null,"NHSNumber"]
[null,{"$f":"EOMONTH(TODAY(),-2)+1","v":"2016-07-01"},{"$f":"EOMONTH(TODAY(),-1)","v":"2016-07-31"},null,1,null,null,null,null,null,null,"Surname"]
[null,null,null,null,null,null,null,null,null,null,null,"Forename"]
[null,null,null,null,null,null,null,null,null,null,null,"DOB"]
[null,null,null,null,null,null,null,null,null,null,null,"Gender"]
[null,null,null,null,null,null,null,null,null,null,null,"Ethnicity"]
[null,null,null,null,null,null,null,null,null,null,null,"HouseName"]
[null,null,null,null,null,null,null,null,null,null,null,"HouseNo"]
[null,"Note that the 1st column called \"APPT_ID\" is linked to the actual slot time reference",null,null,null,null,null,null,null,null,null,"RoadName"]
[null,"which can be cross referenced when running the Cancellation Appointment Wizard",null,null,null,null,null,null,null,null,null,"Locality"]
[null,null,null,null,null,null,null,null,null,null,null,"Town"]
[null,"This will only work with DLM485+",null,null,null,null,null,null,null,null,null,"Postcode"]
[null,"Last updated: August 2016 v1.3",null,null,null,null,null,null,null,null,null,"PracticeCode"]
[null,"1.2 = Updated for large practices with list sizes exceeding 65K",null,null,null,null,null,null,null,null,null,"GP/SurgeryDetails"]
[null,"1.3 = Updated to enclose square brackets around all practice codes that have none, for script purposes.",null,null,null,null,null,null,null,null,null,"Practice Code & Surgery Details is using these Read codes"]
[null,null,null,null,null,null,null,null,null,null,null,"9b1F.% OR 9121.% OR 916..%"]
[null,"NOTE:"]
[null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,"                        If \"From\" date shows an error. Switch on the Analysis ToolPak via Tools menu > Addins"]